Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
JR__Bob__Dobbs
Enthusiast
JR__Bob__Dobbs
Enthusiast
Activity
‎Aug 30, 2012
10:16 AM
The cfcontent tag with reset in your code is clearing out the output buffer so none of the content above the cfcontent tag is sent to the browser. Try something like this: <!--- create a PDF file and store in memory, use the name attribute of cfdocument ---> <cfdocument format="pdf" name="report"> This is the text of the report </cfdocument> <!--- write to browser using the cfcontent tag, you can add a cfheader to specify an attachment name and dispostion if desired Note use of variable attribute to specify the content to be output. The reset attribute will cause any text prior to the PDF content to be removed from the output. This is generally desirable with working with non-HTML content such as PDF files. ---> <cfcontent type="application/pdf" reset="yes" variable="#report#">
... View more
‎Jul 31, 2012
06:27 AM
To clarify. I would increase the postParametersLimit value to handle a larger number of form fields. I would increase the postSizeLimit to handle large form submissions, such as when uploading (posting) files from client to server.
... View more
‎Jul 31, 2012
06:24 AM
You might investigate the postParametersLimit and postSizeLimit values in your server's neo-runtime.xml file. I suspect you'll need to increase the values for those two settings. Remember to back up this file before making any changes. You will need to restart the CF server to apply any changes made to the settings in this file. See the CF 9.0.2 release notes for more information: http://helpx.adobe.com/coldfusion/release-note/coldfusion-9-0-update-2.html
... View more
‎Jul 13, 2012
12:09 PM
Your code and sample appear to work. I was able to get a basic sample to work correctly on my local machine. I suspect that the log file may have some empty fields and/or extra line breaks which are causing problems. I assumed that a line breaks follows the closing curly brace for each record in you sample data. Here is the code I used: <!--- http://forums.adobe.com/message/4556466#4556466 ---> <cfset logpath = expandpath(".") & "\actionlog.txt"> <cffile action="read" file="#logpath#" variable="logfile"> <html> <head> <title>CFFORUM QUESTION</title> </head> <body> <table border="1"> <cfloop index="thisrow" list="#logfile#" delimiters="#chr(10)#"> <tr> <cfoutput> <td>#listgetat(thisrow,1,"|")#</td> <td>#listgetat(thisrow,2,"|")#</td> <td>#Dateformat(listgetat(thisrow,3,"|"),"dd/mm/yyyy")# #Timeformat(listgetat(thisrow,3,"|"),"h:mm:sstt")#</td> </cfoutput> </tr> </cfloop> </table> </body> </html>
... View more
‎Jul 13, 2012
07:31 AM
Perhaps you could post the relavent code to go with the sample data. This would help in troubleshooting your problem.
... View more
‎Jun 29, 2012
06:30 AM
In regards the command line issue: 1. Are any exceptions thrown when using CFEXECUTE? If so what are the error messages? 2. This might be a permissions issue. Does the account that the CF server runs as have sufficient rights to execute the vbs script and/or access the fax components? In regards to the .NET issue, I'm afraid my experience using COM from a .NET assembly is limited. You might try a .NET specific forum for assistance with that issue.
... View more
‎May 22, 2012
02:17 PM
My comment and possibly the error message you are reporting relates to the fact that not all DLLs are .NET assemblies. I suspect that FXSCOMEX.DLL is a COM component, and not a .NET assembly. In order to access the DLL's functionality you may need to create a .NET class that invokes the COM component. Googling ".net com wrapper" or a similar phrase should get you started in the right direction.
... View more
‎May 22, 2012
09:58 AM
I suspect that FXSCOMEX.DLL is not a .NET assembly. You might try one or more of the following options. 1) Create a .NET component which wraps the Fax component. Call the .NET component via cfinvoke or cfobject. See: http://www.codeproject.com/Questions/260306/How-to-initialize-FAXCOMEXLib-FaxServer http://stackoverflow.com/questions/3663338/sending-fax-through-net-c 2) Create a Visual Basic Script that can be invoked at the command line via cfexecute. See: http://msdn.microsoft.com/en-us/library/ms692936.aspx 3) Use a third party web service such as Interfax ( www.interfax.net ).
... View more
‎May 04, 2012
06:28 AM
You might also use SQL Profiler to view the query that is being excuted. "SQL Server Profiler Step by Step" http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step "Getting ColdFusion SQL Statements from SQL Server Trace" http://www.petefreitag.com/item/674.cfm
... View more
‎Apr 09, 2012
08:57 AM
1 Upvote
I have not experienced any problems with having the .NET framework installed on the same server as ColdFusion. I am assuming you are *not* planning to use the .NET features builit into CF. I would be more concerned with the security risks involved in putting accounting data on a web server rather than a file server which is isolated from the Internet by a firewall.
... View more
‎Mar 29, 2012
05:54 AM
Thanks for the assistance Charlie. I've applied cumulative hotfix 3 and no longer see any file upload problems.
... View more
‎Mar 28, 2012
05:56 AM
Bear in mind that the hf801-*.jar files are the hotfix patch files. If you delete the hf801-00005.jar file you are removing the hotfix. Message was edited by: JR \"Bob\" Dobbs
... View more
‎Mar 26, 2012
02:13 PM
Has anyone tested the security hotfix along with Cumulative Hot Fix 4 for CF 8.0.1? Does Cumulative Hot Fix 4 also resolve the file upload issues or does a server need Cumulative Hot Fix 3 specifically?
... View more
‎Mar 21, 2012
12:22 PM
I'd start with reviewing Microsoft's documentation. http://msdn.microsoft.com/en-us/library/ms191227.aspx
... View more
‎Mar 21, 2012
12:16 PM
What database product and version are you using?
... View more
‎Mar 21, 2012
11:04 AM
This probably means that the query is not complicated for the server to parse, but that the work of finding the rows that match your WHERE clause is time consuming. I will repeat the recommendation that you index the column(s) used in your WHERE clause.
... View more
‎Mar 21, 2012
10:59 AM
ACS LLC wrote: Do you believe that there are cases where the same CFquery which is bound correctly vs a stored proc could give different performance results? Differences that are worth actually bothering about? The performance benfits of using stored procs come from the database server re-using the same execution plan. Execution plans can also be re-used for SQL statements with bound parameters, so the performance benefits *should* be about the same. You would need to use your database's performance monitoring tools to test this assumption. Not all database systems act the same in how they optomize queries. I also agree with cfsearching's statement that there is no single right solution to improving query performance. That being said; I *suspect* that creating an index on the columns used in your WHERE clause will be more beneficial than creating a stored proc. I encourage you to investigate the performance monitoring tools available for your database product. Forum users don't have access to your organization's database so any advise we give is limited.
... View more
‎Mar 21, 2012
08:43 AM
ACS LLC wrote: Sorry for my ignorance on this but how do you define a parameterized SQL Query? A parameterized query uses bound parameters. In ColdFusion one uses cfqueryparam to add bound parameters. For example (this assumes that the ipfrom column is a bigint column): <cfquery name="countryLookup"> SELECT country FROM ipcountry WHERE ipfrom <= <cfqueryparam value="#ipnumber#" cfsqltype="cf_sql_integer"> AND ipto >= <cfqueryparam value="#ipnumber#" cfsqltype="cf_sql_integer">; </cfquery> References: CFQUERYPARAM http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html Message was edited by: JR \"Bob\" Dobbs
Corrected typo in cfqueryparam tags.
... View more
‎Mar 21, 2012
08:23 AM
Bear in mind that database servers, such as Microsoft SQL Server, will cache the execution plan for parameterized SQL queries which will result in performance gains similar to use of a stored procedure. You might try using CFQUERYPARAM in your queries. This is also recommended to help prevent SQL injection attacks. You might also create indexes on the ipfrom column on your table.
... View more
‎Mar 20, 2012
08:27 AM
After applying the fix for APSB12-06 the exception below is logged when attempting to upload a file via a form post. java.lang.NoSuchMethodError: com.oreilly.servlet.multipart.MultipartParser.<init>(Ljavax/servlet/http/HttpServletRequest;J)V at coldfusion.filter.FormScope.fillMultipart(FormScope.java:177) at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:436) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:33) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:198) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) This occurs on every post which includes a file, regardless of the post/file size. I have edited my neo-runtime.xml file per the patch instructions. Note that the site on which I am seeing this problem uses basic authentication. If I remove the file {ColdFusion-Home}/lib/updates/hf801-00005.jar and restore the file hf801-00004.jar (which was removed per the patch instructions) the exception no longer occurs. My environment: OS: Windows 2003 Server R2, service pack 2, 32bit ColdFusion: 8.0.1 with all previous security hotfixes applied JVM: 1.6.0_24 Is there a fix for this problem? References: ColdFusion Security Hotfix APSB12-06 http://helpx.adobe.com/coldfusion/kb/coldfusion-security-hotfix.html
... View more
‎Mar 20, 2012
08:12 AM
Given that the error message you've posted includes "PostParametersLimitExceededException" you might try editing your neo-runtime.xml file adding the line below: <var name='postParametersLimit'><number>100.0</number></var> See: http://helpx.adobe.com/coldfusion/kb/coldfusion-security-hotfix.html
... View more
‎Mar 09, 2012
08:35 AM
1 Upvote
rockhiker, I suggest that you get the query to work in Access, then work on the ColdFusion code. In order to assist you it would be useful to have. 1. The table structure. 2. The query, if the one in your sample code has changed. 3. A sample of the data. 4. The results desired from executing the query against the data sample. 5. Error messages, if any you encounter. I will also agree with Owain North that using MS Access in a web application is not a good idea. Access was designed for a single user or small workgroup, not as a backend for multi-user applications such as web sites. I suggest that you look into alternatives such as: 1. MS SQL Server. Pros: Should be relatively easy to move from Access to SQL Server. Cons: Licensing costs. 2. If cost is an issue you might use an open-source product such as PostgreSQL or MySQL. 3. ColdFusion includes the Java based Derby DB. See Charlie Arehart's site for info on Derby. http://carehart.org/resourcelists/derby_for_CFers/ 3. Other. There are many good database products the one you pick should fit the needs of your organization and your IT infrastructure.
... View more
‎Mar 09, 2012
05:58 AM
I sounds like you will need to use the COUNT() function provided by whatever database product you are using to count the number of student records associated with each class. Your posted cfquery is close, but I'm not sure what the "8-" is supposed to do.
... View more
‎Mar 08, 2012
02:22 PM
To store a file path in a database table treat the path as a string, normally a VARCHAR column in a database. You can associate these database records with a tech support incident. Just INSERT a record for each file to be stored. To download the file supply the file's path to CFCONTENT. References: CFCONTENT http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7c82.html http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec1553c-7feb.html
... View more
‎Mar 08, 2012
01:20 PM
You might consider refactoring your code to remove the dependency on a url scope variable. This would allow you to use the CFC to query by video based on a form field or other value. <cffunction name="pagevideo" access="public" returntype="query"> <cfargument name="videoId" type="numeric" required="yes"> <cfquery name="pagevideo" datasource="videos"> SELECT video_path, ID, Video_Name FROM Video WHERE ID = <cfqueryparam value="#arguments.videoId#" cfsqltype="cf_sql_integer"> </cfquery> <cfreturn pagevideo> </cffunction> CFM page: <cfset myObj = createObject("component","cfc.page") /> <cfset queryObj = myObj.pagevideo(videoId=url.VideoID)> Message was edited by: JR \"Bob\" Dobbs Message was edited by: JR \"Bob\" Dobbs
... View more
‎Mar 08, 2012
01:14 PM
It appears that you have an extra comma after Video_Name in your query. I suspect that this is causing the error. The CFQUERYPARAM tag is used to bind parameters to your SQL statements. Use of bound parameters is recommended to avoid SQL injection attack vulnerability. See: Assuming that the ID column is an integer: <cfquery name="pagevideo" datasource="videos"> SELECT video_path, ID, Video_Name FROM Video WHERE ID = <cfqueryparam value="#URL.VideoID#" cfsqltype="cf_sql_integer"> </cfquery> References: CFQUERYPARAM http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f6f.html SQL Injection (Wikipedia) http://en.wikipedia.org/wiki/Sql_injection
... View more
‎Mar 08, 2012
01:01 PM
Does the server hosting the service use basic authentication? CF cannot use Windows authentication.
... View more
‎Mar 08, 2012
01:00 PM
What is the error message, if any, you receive. I also that the variable aged240video in your cfreturn is not defined. Try <cfreturn pagevideo> instead. You should also omit the line <cfset var pagevideo="">. You should also use CFQUERYPARAM in your query when passing in URL.VideoID.
... View more
‎Feb 17, 2012
01:05 PM
When converting a query object to JSON ColdFusion does not create an array of key/value pairs. The format used is documented at http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-79fa.html I suspect that in order to get key/value pairs you will need to write your own conversion code.
... View more
‎Feb 15, 2012
01:07 PM
See sample below. Note that this has not been tested. <!--- create a query result object named directoryContent to contain listing of XML files ---> <cfdirectory directory="C:\locates\xmlLocateAttachments" action="list" filter="*.xml" name="directoryContent"> <!--- iterate over files ---> <cfloop query="directoryContent"> <!--- create file name string ---> <cfset fileFullPath="#directoryContent.directory#/#directoryContent.name#"> <!--- read file ---> <cfset fileContent=FileRead(fileFullPath)> <!--- assumes that you are inserting XML as a string into a MySQL database table's LONGTEXT column ---> <cfquery name="insertXmlData"> INSERT INTO some_table ( entry_date, xml_text ) VALUES ( <cfqueryparam value="#Now()#" cfsqltype="cf_sql_date">, <cfqueryparam value="#fileContent#" cfsqltype="cf_sql_longvarchar"> ); </cfquery> </cfloop>
... View more
Get ready! An upgraded Adobe Community experience is coming in January.
Learn more
Copyright © 2025 Adobe. All rights reserved.
AdChoices